package org.bonorsoft.modules.control.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.bonorsoft.modules.control.entity.House;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.bonorsoft.modules.control.entity.Label;

/**
 * @Description: 实有房屋信息
 * @Author: WilliamYe
 * @Date:   2021-03-01
 * @Version: V1.0
 */
public interface HouseMapper extends BaseMapper<House> {

    @Select("select " +
            "l.label_id, l.label_name " +
            "from " +
            "police_label l " +
            "left join ybss_fw_syfw f " +
            "on f.bq like concat('%',concat(l.label_id,'%')) " +
            "where " +
            "f.dzbm = #{dzbm}")
    List<Label> getLable(String dzbm);

}
